package com.supermap.application.dao;

import com.supermap.application.entity.TMicroIdenvl;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface MicroIdenvlDao extends JpaRepository<TMicroIdenvl,Integer> {

    @Query("select  t from TMicroIdenvl t where t.TMicroIdent.miitid=:id and t.status =1 ")
    List<TMicroIdenvl> findByTMicroIdent(@Param("id") int id);

}
